﻿using System;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.Text;

namespace QLThuHocPhi
{
    class Select
    {
        string strCnn = System.Configuration.ConfigurationSettings.AppSettings["Mycnn"].ToString();
        public string NvId(string id)
        {
            string strSQL = "Select dbo.fc_NVID ('" + id + "')";
            SqlConnection sql = new SqlConnection(strCnn);
            sql.Open();
            SqlCommand myCommand = new SqlCommand(strSQL, sql);
            string strresult = myCommand.ExecuteScalar().ToString();
            return strresult;
        }
    }
}
